package com.czc.cca.ddl;

import org.zoomdev.zoom.dao.ddl.*;
import org.zoomdev.zoom.dao.driver.mysql.MysqlDriver;

@_DDL_Table(name = "act_cashback", simpleName = "", engine = MysqlDriver.InnoDB, comment = "商户返现活动配置")
public class _DDL_ActCashback {

    @_DDL_Primary()
    @_DDL_Column(name = "id", type = SqlType.INT_UNSIGNED, nullable = false, autoIncrement = true, comment = "活动id")
    private Long id;

    @_DDL_Index(name = "IDX_act_cashback_mer_id")
    @_DDL_Column(name = "mer_id", type = SqlType.BIGINT_UNSIGNED, comment = "商户id")
    private java.math.BigInteger merId;

    @_DDL_Index(name = "IDX_act_cashback_shp_id")
    @_DDL_Column(name = "shp_id", type = SqlType.INT_UNSIGNED, comment = "门店id")
    private Long shpId;

    @_DDL_Column(name = "state", type = SqlType.TINYINT_UNSIGNED, nullable = false, comment = "状态码 0 正常 1 关闭")
    private Integer state;

    @_DDL_Column(name = "cr_time", type = SqlType.TIMESTAMP, defaultFunction = MysqlDriver.CURRENT_TIMESTAMP, comment = "创建时间")
    private java.sql.Timestamp crTime;

    @_DDL_Column(name = "back_rate", type = SqlType.DECIMAL, size = 8, scale = 2, comment = "返现百分比")
    private java.math.BigDecimal backRate;

    @_DDL_Column(name = "total_amt", type = SqlType.DECIMAL, size = 10, scale = 2, comment = "总金额")
    private java.math.BigDecimal totalAmt;

    @_DDL_Column(name = "total_back", type = SqlType.DECIMAL, size = 10, scale = 2, comment = "总返现")
    private java.math.BigDecimal totalBack;

    @_DDL_Column(name = "start_date", type = SqlType.INT_UNSIGNED, comment = "开始日期")
    private Long startDate;

    @_DDL_Column(name = "end_date", type = SqlType.INT_UNSIGNED, comment = "结束日期")
    private Long endDate;

}
